﻿CREATE PROCEDURE [dbo].[AddProjectMemberWithRate]
@ID UNIQUEIDENTIFIER, @projectID INT, @userID INT, @startDate DATETIME, @endDate DATETIME, @hourlyRate MONEY
AS
INSERT INTO ProjectMembers
(
	ID,
	ProjectID,
	UserID,
	StartDate,
	EndDate,
	HourlyRate	
)
VALUES
(	
	@ID,
	@projectID,
	@userID,
	@startDate,
	@endDate,
	@hourlyRate	
)

